Notes/Domino 6 and 7 Forum : RE: Can't connect to SQL via ODBC

Notes/Domino 6 and 7 Forum

RE: Can't connect to SQL via ODBC

RE: Can't connect to SQL via ODBC
Posted by ~Yentl Kifreeterynds on 19.Jan.04 at 02:02 PM using a Web browser
Category: Domino Designer

Release: 6.0.1 CF1

Platform: Windows 2000

Hi,

Try this.....

"Sub Click(Source As Button)
Dim ws As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Set uidoc = ws.CurrentDocument
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Set qry.Connection = con
Set result.Query = qry
If con.ConnectTo("ODBC","username", "password"Then
qry.SQL = "Query"
result.Execute
If result.Execute Then
action
End If "

I Hope this help

Regards